create  table jms_dm.dm_outfield_person_order_sum_dt
(
date_time  date COMMENT '业务日期' ,
pick_staff_code    varchar(100) COMMENT '取件业务员编码' ,
pick_staff_name  varchar(100) COMMENT '取件业务员名字' ,
taking_success_sum  bigint COMMENT '揽收成功总量' ,
order_taking_fail_sum   bigint COMMENT '揽收失败总量'
 )
ENGINE=OLAP
DUPLICATE KEY(date_time,pick_staff_code)
comment '星级排名需求（业务员订单揽收情况)'
PARTITION BY RANGE (date_time) (
   START ('2022-08-10') END ('2023-01-19') EVERY (INTERVAL 1 day))
   DISTRIBUTED BY HASH(pick_staff_code) BUCKETS 4
PROPERTIES (
'replication_num' = '1',
'dynamic_partition.enable' = 'true',
'dynamic_partition.time_unit' = 'DAY',
'dynamic_partition.time_zone' = 'Asia/Shanghai',
'dynamic_partition.start' = '-180',
'dynamic_partition.end' = '3',
'dynamic_partition.prefix' = 'p',
'dynamic_partition.buckets' = '4',
'in_memory' = 'false',
'storage_format' = 'V2'
)